// 仓库列表
const {DataTypes, db } = require("../db");
db.define('storage', {
id: {type: DataTypes.INTEGER, primaryKey: true, autoIncrement: true,comment:'表自增ID'},
tenantId:{type: DataTypes.INTEGER,allowNull:false,comment:'租户ID'}, 
code:{type: DataTypes.STRING(255),comment:'编码'}, 
name:{type: DataTypes.STRING(20),allowNull:false,comment:'仓库名称'}, 
contact:{type: DataTypes.STRING(30),comment:'联系人'}, 
phone:{type: DataTypes.STRING(20),comment:'电话'}, 
address:{type: DataTypes.STRING(50),comment:'仓库地址'}, 
pinYin:{type: DataTypes.STRING(255),comment:'拼音'}, 
disabled:{type: DataTypes.TINYINT,defaultValue:0,comment:'状态 0正常  1锁定 2删除'}, 
isInit:{type: DataTypes.INTEGER,defaultValue:0,comment:''}, 
isDel:{type: DataTypes.INTEGER,defaultValue:0,comment:''}, 
cby:{type: DataTypes.INTEGER,comment:''}, 
ctime:{type: DataTypes.STRING(20),comment:''}, 
uby:{type: DataTypes.INTEGER,comment:''}, 
utime:{type: DataTypes.STRING(20),comment:''}, 
dby:{type: DataTypes.INTEGER,comment:''}, 
dtime:{type: DataTypes.STRING(20),comment:''}, 

}, {
    tableName: 'storage',
    timestamps: false,
    comment: '仓库列表',
    
});